﻿CREATE TABLE [dbo].[tair_Events] (
    [ID]        INT           IDENTITY (1, 1) NOT NULL,
    [ESN]       VARCHAR (11)  NOT NULL,
    [EventCode] INT           NOT NULL,
    [EventName] VARCHAR (128) NULL,
    [longitude] FLOAT         NULL,
    [latitude]  FLOAT         NULL,
    [Date]      SMALLDATETIME NOT NULL,
    [Address]   VARCHAR (256) NULL
);

